Create Staging Tables in Staging Database and Populate the Staging Tables - Continued 9

To Load Stg_Req Table:

Source Vw_ReqA:

Source VW_SIH:

Source Timing::

SQL command Text:

SELECT [Job Posting ID] ,[Supplier Response], [Selection Process], [Onboarding],

MIN ([Job Posting Approval/Distribution] ) as [Min_Job Posting Approval/Distribution]

FROM [dbo].[Timing]

Group By [Job Posting ID], [Supplier Response], [Selection Process], [Onboarding]

Sort:

Sort 1:

Sort 2:

Merge Join:

Sort 3:

Merge Join 1:

Data Conversion:

Derived Column:

Derived Column Text:

ISNULL([Str_SIH_Min Presented Bill Rate (ST/Hr)]) ? "0" : [Str_SIH_Min Presented Bill Rate (ST/Hr)]

ISNULL([Str_SIH_Max Presented Bill Rate (ST/Hr)]) ? "0" : [Str_SIH_Max Presented Bill Rate (ST/Hr)]

ISNULL([Str_SIH_Max Requested Bill Rate (ST/Hr)]) ? "0" : [Str_SIH_Max Requested Bill Rate (ST/Hr)]

ISNULL([Str_SIH_Min Requested Bill Rate (ST/Hr)]) ? "0" : [Str_SIH_Min Requested Bill Rate (ST/Hr)]

ISNULL([Str_Min_Job Posting Approval/Distribution]) ? "0" : [Str_Min_Job Posting Approval/Distribution]

OLEDB Destination:

About Derived Column Transformation

https://www.sqlshack.com/ssis-derived-columns-with-multiple-expressions-vs-multiple-transformations/